SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 41333: A horizontal series bar chart might sort incorrectly in SAS® Web Report Studio

DetailsAboutRate It

In SAS Web Report Studio, you can create a horizontal series bar chart. If multiple categories are included in the horizontal series axis, you might get unexpected results when sorting on the bar value. In the following example, the horizontal series axis includes Region, Division, and Product. Product Type is assigned to the Bars.

image label

If you sort Product Type in ascending order, then Product sorting is inconsistent, as shown in the following example. Specifically, in the Eastern region, Product is sorted as Bed, Chair, Desk, Sofa, Table; while, in the Western region, Product is sorted as Bed, Sofa, Chair, Desk, Table. To circumvent the problem, you must also sort Product in ascending order.

image label



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Web Report Studioz/OS4.2_M24.319.2 TS2M39.3 TS1M0
Microsoft® Windows® for x644.2_M24.319.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 Datacenter Edition4.2_M24.319.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 Enterprise Edition4.2_M24.319.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 Standard Edition4.2_M24.319.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 for x644.2_M24.319.2 TS2M39.3 TS1M0
Microsoft Windows Server 20084.2_M24.319.2 TS2M39.3 TS1M0
Microsoft Windows Server 2008 for x644.2_M24.319.2 TS2M39.3 TS1M0
Microsoft Windows XP Professional4.2_M24.319.2 TS2M39.3 TS1M0
Windows 7 Enterprise 32 bit4.2_M24.319.2 TS2M39.3 TS1M0
Windows 7 Enterprise x644.2_M24.319.2 TS2M39.3 TS1M0
Windows 7 Home Premium 32 bit4.2_M24.319.2 TS2M39.3 TS1M0
Windows 7 Home Premium x644.2_M24.319.2 TS2M39.3 TS1M0
Windows 7 Professional 32 bit4.2_M24.319.2 TS2M39.3 TS1M0
Windows 7 Professional x644.2_M24.319.2 TS2M39.3 TS1M0
Windows 7 Ultimate 32 bit4.2_M24.319.2 TS2M39.3 TS1M0
Windows 7 Ultimate x644.2_M24.319.2 TS2M39.3 TS1M0
Windows Vista4.2_M24.319.2 TS2M39.3 TS1M0
Windows Vista for x644.2_M24.319.2 TS2M39.3 TS1M0
64-bit Enabled AIX4.2_M24.319.2 TS2M39.3 TS1M0
64-bit Enabled Solaris4.2_M24.319.2 TS2M39.3 TS1M0
HP-UX IPF4.2_M24.319.2 TS2M39.3 TS1M0
Linux for x644.2_M24.319.2 TS2M39.3 TS1M0
Solaris for x644.2_M24.319.2 TS2M39.3 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.